space
Previous Page | Next Page

SAS Namespace Types

ForeignKey


Subclass of Key


Overview

Represents the fact that a table contains a foreign key to another table.

Security Inheritance and Enforcement Rules

The following list of associations is used to determine if this object should inherit access controls from another object (inheritance), or if the association is allowed for the object (enforcement). An association will not be created unless the calling user is authorized to update one or both objects involved in the association. For more information about inheritance and enforcement rules, see the SAS Intelligence Platform: Security Administration Guide.

Attributes

Inherited Attributes
Name, Id, Desc, MetadataCreated, MetadataUpdated, ChangeState, LockedBy, SecTransctxt, UsageVersion

Associations

= indicates the resident side of an association, or where the association is persisted for cross-repository associations. If no resident side is indicated, this association may not cross repository boundaries.
Name Cardinality Description Associated Types
KeyAssociations

Partner: OwningForeignKey

0 to * The list of association object s that associate a column in this foreign key to a column in the unique key.  KeyAssociation
PartnerUniqueKey

Partner: ForeignKeys

0 to 1 The unique key associated with this foreign key.  UniqueKey
Table

Partner: ForeignKeys

1 to 1 The table that contains this foreign key.  DataTable
ExternalTable
JoinTable
PhysicalTable
QueryTable
RelationalTable
TableCollection
WorkTable

Inherited Associations
AccessControls/Objects, Changes/Objects, CustomAssociations/OwningObject, DisplayColumns/DisplayForKeys, Documents/Objects, Extensions/OwningObject, ExternalIdentities/OwningObject, Groups/Members, Implementors/ImplementedObjects, KeyedColumns/Keys, Keywords/Objects, LocalizedAttributes/AssociatedLocalizedObject, Notes/Objects, PrimaryPropertyGroup/AssociatedObject, Prompts/PromptEnabledObject, Properties/AssociatedObject, PropertySets/OwningObject, ReferencedObjects/AssociatedObjects, ResponsibleParties/Objects, SourceTransformations/TransformationSources, SpecSourceTransformations/SourceSpecifications, SpecTargetTransformations/TargetSpecifications, TargetTransformations/TransformationTargets, Timestamps/Objects, Trees/Members, TSObjectNamespace/TSObjects, UsedByPrototypes/UsingPrototype, UsingPrototype/UsedByPrototypes, Variables/AssociatedObject

Association Details

KeyAssociations
     Cardinality:   0 to *
     Partner:   OwningForeignKey

The list of association objects that associate a column in this foreign key to a column in the unique key. 

Associated Types:
KeyAssociation

PartnerUniqueKey
     Cardinality:   0 to 1
     Partner:   ForeignKeys

The unique key associated with this foreign key. 

Associated Types:
UniqueKey

Table
     Cardinality:   1 to 1
     Partner:   ForeignKeys

The table that contains this foreign key. 

Associated Types:
DataTable, ExternalTable, JoinTable, PhysicalTable, QueryTable, RelationalTable, TableCollection, WorkTable

Previous Page | Next Page | Top of Page